
	load data
	INFILE './tmp/allData.data '
	BADFILE './tmp/600000.ss.bad'
	DISCARDFILE './tmp/600000.ss.dis'
	INTO TABLE stockinfo
	APPEND
	FIELDS TERMINATED BY ',' 
	(stockdate date 'yyyy-mm-dd',
	 open     ,
	 high     ,
	 low      ,
	 close     ,
	 volume    ,
	 adjclose  ,
	 stockcode ) 
	 
	
